package com.apexedu.eas.dao.impl;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.apexedu.eas.annotation.Query;
import com.apexedu.eas.constants.Constant;
import com.apexedu.eas.entity.CommonPojo;
import com.apexedu.eas.entity.TJc;
import com.apexedu.eas.entity.TZc;
import com.apexedu.eas.entity.TjxKc;
import com.apexedu.eas.entity.TjxZy;



@Repository
public class InitDao {

	
	
	@Query("select a.id as id,a.jsmc as caption from t_js_gxjx0601 a" +
			" where a.sfkpk=1 and sfqy=1 order by a.jzw,a.szlc,a.jsh")
	public List<CommonPojo> getPkjs(){
		return null;
	}
	
	@Query("select a.id,a.xm||'('||a.gh||')' as caption from gxjg0101 a order by a.gh")
	public List<CommonPojo> getRkjs(){
		return null;
	}
	
	@Query("select a.id,a.xm||'('||a.gh||')' as caption from gxjg0101 a  order by a.gh")
	public List<CommonPojo> getJkjs(){
		return null;
	}
	
	@Query("select a.id as id,a.jsqc as caption,a.jsmc as superid,a.kszws as currid from t_js_gxjx0601 a" +
			" where sfkc=1 and sfqy=1 order by a.jzw,a.szlc,a.jsh")
	public List<CommonPojo> getKcjs(){
		return null;
	}
	
	
	@Query("select id from t_xn where zt=2 order by ksn")
	public Object getCurrXn(){
		return null;
	}
	@Query("select id from t_xq where pkxq=1 order by xn,xqsx")
	public Object getCurrXq(){
		return null;
	}
	
	@Query("select xqmc from t_xq where zt=2")
	public Object getCurrXqName(){
		return null;
	}
	
	@Query("select id from t_nj where njxh=1")
	public Object getCurrNj(){
		return null;
	}
	@Query("select njmc from t_nj where njxh=1")
	public Object getCurrNjmc(){
		return null;
	}
	
	@Query("select id,xnmc as caption,ksn as currid from t_xn order by ksn")
	public List<CommonPojo> getListXn(){
		return null;
	}
	
	@Query("select id,xqmc as caption,xn as superid from t_xq order by xn,xqsx")
	public List<CommonPojo> getListXq(){
		return null;
	}
	
	@Query("select id,name as caption,orgtype as des from lborganization")
	public List<CommonPojo> getListZzjg(){
		return null;
	}
	
	@Query("select id,name as caption,orgtype as des from lborganization where cdkc=1")
	public List<CommonPojo> getListCdxb(){
		return null;
	}
	
	@Query("select id,jyzmc as caption,jyzdm as des from TJX_JSJYZ where sfqy=1")
	public List<CommonPojo> getListJyz(){
		return null;
	}
	
	@Query("select distinct t.hb_jslx as id,s.name as caption from T_JS_GXJX0601 " +
                "t left join t_sjzx_dmjzx s on s.ssdm='HB_JSLX' and s.id=t.hb_jslx where t.sfqy=1")
	public List<CommonPojo> getListJslx(){
		return null;
	}
	
	@Query("select id,name as caption from t_sjzx_dmjzx where ssdm='HB_RKKCLB' and zt=1")
	public List<CommonPojo> getListKclb(){
		return null;
	}
	
	@Query("select id,xzbmc as caption from T_BJ_GXXX04")
	public List<CommonPojo> getListBj(){
		return null;
	}
	
	@Query(value="from TZc where xq = ? order by id" ,nativeQuery=false)
	public List<TZc> getListZc(String currXq){
		return null;
	}
	@Query(value="from TJc order by sd,jc" ,nativeQuery=false)
	public List<TJc> getListJc(){
		return null;
	}
	@Query(value="from TjxZy order by zyh asc" ,nativeQuery=false)
	public List<TjxZy> getListZy(){
		return null;
	}
	
	@Query("select id,njmc as caption,rxnf as currid from t_nj order by rxnf" )
	public List<CommonPojo> getListNj(){
		return null;
	}
	@Query(value="from TjxKc a where  a.hbKcsx is not null order by hb_kcsx,id" ,nativeQuery=false)
	public List<TjxKc> getListKc(){
		return null;
	}
	@Query("select distinct A.id,A.xzbmc as caption,A.xq as des from (select s.id,s.xzbmc,t.xq from TJX_JHJXB t" +
				" left join T_BJ_GXXX04	 s on instr(';'||t.bj||';',';'||s.id||';')>0  order by t.id) A" )
	public List<CommonPojo> getListJxbbj(){
		return null;
	}
	@Query("select id,name as caption,sm as superid" +
			" from T_SJZX_DMJZX where SSDM = 'HB_XZ' and zt = " + Constant.SFKY.YES + " order by dm" )
	public List<CommonPojo> getListXz(){
		return null;
	}
}
